Previous Topic

Next Topic

Creating General Lookup/Validation Tables for Events

The Events module has several General Lookup/Validation tables that help you manage your events:

BADGE_TYPE

This table stores the badge types needed for your events. The Events module comes with two predefined badge types: Free_Pass and Paid_Pass. Free passes come with the purchase of a booth. For example, when setting up your event, if you indicate that each booth unit receives two free passes, that is the number of free passes available to the registrant for each booth unit.

A Paid_Pass is a specific product defined at the event function level. For example, registrants may want to purchase additional badges with their booth order. The BADGE_TYPE information is available from the Register a customer window's Badges tab. As you issue each badge, you can see the number available for each Paid and Free Pass type displayed below the data entry area.

Although the Events module comes with the Free_Pass and Paid_Pass badge types already defined, you can define as many badge types as you need for your particular event. Badge types will be available on the Badges tab only if they have been defined in the BADGE_TYPE General Lookup/Validation table.

CEU_TYPE

This table stores continuing education units (CEU) type codes used for validation and lookup of CEU credit entries if you are not licensed for the Certification module.

If you are licensed for Certification, lookup and validation of CEU Type fields are performed against CEU type codes that are defined in Certification. If this CEU_TYPE table is also populated with CEU type codes, then the codes from both sources are combined and listed alphabetically when you click the CEU Type field's Lookup icon.

Note: If an identical CEU type code exists both in Certification and in the CEU_TYPE table, the code from Certification is used.

CONFLICT_CODE

This table stores codes used in determining date/time conflicts and content conflicts between events. Registering for conflicting event functions will display a warning message.

GL_ACCOUNT

This table stores accounting codes. If the Validate G/L Accounts option is enabled on the AR/Cash General Ledger Interface window, then the table will be used to validate accounting codes. If the option is not enabled, you may enter codes that are not in the table.

MEETING_TYPE

This table stores codes used in distinguishing different types of events, such as CONF for conference and SEM for seminar.

PREFIX

This table stores titles and abbreviated titles that precede a customer's formal name, such as Mr., Ms., and Dr.

SOURCE_CODE

This table stores codes used in specifying the marketing program or contact type that generated an accounting transaction, such as phone and mail. Enable the Force Source Coding option on the Customer Setup - Basic Options window to require source coding.

SUFFIX

This table stores titles and abbreviated titles that follow a customer's formal name, such as Jr., Sr., II, and III.

TITLE

This table stores professional titles and positions, such as CEO, COO, and CMO.

In This Section

Set up general lookup/validation window

To create General Lookup/Validation tables for events

See Also

Events System Setup

Events System Setup Overview

Performing Basic Event System Setup

Enabling Event System Preferences

Enabling Event Wait Lists

Mapping User-Defined Fields to Event Activity Records

Setting up Events Advanced Features


ASI logo 10.6 Production Release. Updated 1/20/2006 4:45:42 PM
© Copyright by Advanced Solutions International, Inc. All rights reserved.